package com.core.website.mapper;

import com.core.website.entity.Column;
import com.core.website.entity.IpEntity;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface IpMapper {
    IpEntity queryByColumnAndIp(@Param("columnId") String columnId,@Param("ip") String ip);
    int add(@Param("id") String id,@Param("columnId") String columnId,@Param("ip") String ip);
    int update(@Param("id") String id,@Param("columnId") String columnId,@Param("ip") String ip);
    List<IpEntity> queryPage(@Param("columnId") String columnId,@Param("ip") String ip);
    List<IpEntity> queryAll();
    void delete(List<String> list);
    List<Column> queryFilterColumn(@Param("ip") String ip);
    void deleteStatisticalIpSetting();
    void statisticalIpSetting(@Param("list") List<String> ipList);
    List<String> statisticalIpSearch();
    int statisticalIpTotal();
    void addStatisticalIpTotal();
    void first(String ip);
    int checkFirst(String ip);
    String getFirstSwich();
    int updateFirstSwich(String swich);
    List<IpEntity> selectIpListByColumn(String columnId);
}
